[Bug]: update card_type based on the bin list in transaction table

Repo: · Issue: #1093 Status: Open · Priority: P2 Assignee: Ahmad1809 Labels: bug

Description

Steps to reproduce

card_types in transaction table are inconsistent so we update them directly based ont heir account_first_6(bin code)

Expected behavior

we have card type equal to:

  • VS: VISA
  • MC: Mastercard
  • DS: DIscover
  • AM: Amex
  • other

This will be used in the calculation of current commission and other kpis.

Actual behavior

we have multiple card types.

Implementation Notes

Dash adds notes here while working

Link to people, meetings, dependent tickets